CREATE TABLE [dbo].[Customer_Order_Items]
(
[OrderItemsId] [bigint] NOT NULL IDENTITY(1, 1),
[OrderId] [bigint] NULL,
[ItemId] [bigint] NOT NULL,
[Quantity] [int] NULL,
[GrossWeight] [decimal] (18, 3) NULL,
[Tarugu] [decimal] (18, 3) NULL,
[NetWeight] [decimal] (18, 3) NULL,
[MakingCharge] [decimal] (18, 0) NULL,
[StonesWeightCt] [nchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StonesCost] [decimal] (18, 0) NULL,
[Length] [decimal] (18, 0) NULL,
[ImagePath] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DelivaryDate] [datetime] NOT NULL,
[Status] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Customer_Order_Items] ADD CONSTRAINT [PK_Customer_Order_Items] PRIMARY KEY CLUSTERED  ([OrderItemsId]) ON [PRIMARY]
GO
